*Creates database with d, ell, m and ab
*d: government debt to GDP ratio
*ell: government debt held by domestic banks to GDP ratio
*m: currency and deposits to GDP ratio
*ab: bank loans to GDP ratio
*Olivier Jeanne, 11/2024, edited 12/2025

clear

use "ASBS.dta" 

rename D_GDP d
gen ell=( DomB+ DomCB)/ Total*d
gen m= CurrencyDeposits/ Total* d
gen ab= Loans / Total* d
gen domnb= DomNbanks / Total* d

keep Country ISO G7 Euro Year d ell m ab domnb
order Country ISO Year G7 Euro d ell m ab domnb
drop if ISO=="GRC"  
*Greece is dropped because it defaulted

label var ell "Domestic bank-held government debt (% of GDP)"
label var m "Currency and deposits (% of GDP)"
label var ab "Bank loans (% of GDP)"

save "C:\Users\ojeanne1\Documents\newpapers\Financial repression\Data\Replication\ASBSnorm.dta", replace
